UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'k8uG6zQO8Faitw66JTBmIvA+y5TQ+8TfhfFBsRiGipU=' 
WHERE 
  key_id = 'e7fb6a66552b877e188bfd590c95ca753d47418a6f19940f5c055e4f25e9b0ed' 
  AND (
    token = 'k8uG6zQO8Faitw66JTBmIvA+y5TQ+8TfhfFBsRiGipU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031