UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6njmH9JjrLkCZBTv1HCiEEBKunsnILKhM77xlfVQwCA='
WHERE
key_id = '8fb9af4a99c9b1068cb8b9ed5ddbb823d35d582df9ff466b531a7ef1946b668d'
AND (
token = '6njmH9JjrLkCZBTv1HCiEEBKunsnILKhM77xlfVQwCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)