UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yKLBMf2zwMUuGdZddfCIplIPgR0dx9Q7k7mVlMVRCUQ=' 
WHERE 
  key_id = '77a226abec4e58d36ffe505b158f8c5e2d5badb2681f3c2efdfa86fcdc2012ae' 
  AND (
    token = 'yKLBMf2zwMUuGdZddfCIplIPgR0dx9Q7k7mVlMVRCUQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017