UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kRfu3PkPE9f6rfUo8Ce3eH3DP+mX56wR9rIM2Evhmm0=' 
WHERE 
  key_id = '9809be79278391d87e2ca7f32ab0ef0cf98aacf130ec8d94a0aefbc9e516a9f2' 
  AND (
    token = 'kRfu3PkPE9f6rfUo8Ce3eH3DP+mX56wR9rIM2Evhmm0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031