UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1eSPSTfbIR5eJoe/ow+y7Dt4w0Bl/731H/4L7fcmV8w=' 
WHERE 
  key_id = '715d6dad18745d7b6a49e35396314319009b4d76dfce7b6df527d2e7c6c191d6' 
  AND (
    token = '1eSPSTfbIR5eJoe/ow+y7Dt4w0Bl/731H/4L7fcmV8w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027