UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VTXfw3qTZDgitPgcQ+9NQuYdjJ0vW1Q0PlZ5lX4WuFY=' 
WHERE 
  key_id = '939dbbf7762375cd9942d57b54fe031c366b376e2f4bd0f1c3e7bbbea4d89e7c' 
  AND (
    token = 'VTXfw3qTZDgitPgcQ+9NQuYdjJ0vW1Q0PlZ5lX4WuFY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042