UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ln1+EnCTZLAh5HEDbxBkp+eVKIGPh984n1c6+kxuPAI='
WHERE
key_id = '4e5187dbc46afafd0203a4a0c12b75767d71a9bd46d94c1fe84c27757d6ca59a'
AND (
token = 'ln1+EnCTZLAh5HEDbxBkp+eVKIGPh984n1c6+kxuPAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)