UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0PE8ZrAb/l83Kl9Y8ObHN6Ksq9TNdhpscio+lVP/68w=' 
WHERE 
  key_id = '3b5e8001882923eaf18d91d4d92d2188e666cd8d8eb4a2311764f1852dd76143' 
  AND (
    token = '0PE8ZrAb/l83Kl9Y8ObHN6Ksq9TNdhpscio+lVP/68w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037