UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'upBcekobntJ4HUGjGS1V2b2NPTmkt4TOfyRPRAJ//6w=' 
WHERE 
  key_id = '18d2b813615b25cc8a061c3f7c088851b09c8b916c1b59aad856a919c5e4f40d' 
  AND (
    token = 'upBcekobntJ4HUGjGS1V2b2NPTmkt4TOfyRPRAJ//6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040