UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B+pp2nVJ3hewl9O+Q0dR3gjHWCguNcVVROjdrw/Nn7Q=' 
WHERE 
  key_id = '94e83a01037e8ddf116821cddda1d166196b439cfb4d36f2cb1add05b81cf8f7' 
  AND (
    token = 'B+pp2nVJ3hewl9O+Q0dR3gjHWCguNcVVROjdrw/Nn7Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023