UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AC+tNwf1BHv+U1iMG2PXymPxEc9NDS9srgpTHZjvwzc='
WHERE
key_id = 'd04145342ea5e2a580b4c8a17f963b19daab31d60da3bcc7659751857174463d'
AND (
token = 'AC+tNwf1BHv+U1iMG2PXymPxEc9NDS9srgpTHZjvwzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)