UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FcOaApcJ1p5KNGdYxmbUSTcG6b2KiIqpsbf4DZ+YzaU=' 
WHERE 
  key_id = '2a064a26d84f4d91f34d85a1015c45617216d6c17cdf2e61a237787aabd4895b' 
  AND (
    token = 'FcOaApcJ1p5KNGdYxmbUSTcG6b2KiIqpsbf4DZ+YzaU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027