UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5dPInc+i4dOUgZ3CQgt+d0B975cAhQpu9v11kZZpPU0=' 
WHERE 
  key_id = 'e586bd2a2fbbbb99b81f25f5544cf519c121e7ed86c0b643b79f0120db30cf48' 
  AND (
    token = '5dPInc+i4dOUgZ3CQgt+d0B975cAhQpu9v11kZZpPU0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026