UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqzYHRVWOaet3M6XubYXcWZwuBIjd4407NndD4SZhU8='
WHERE
key_id = '559f1e838b8b9331446361cdb6bcfcb4ed6c87b51251d7075f94508ad1ad970c'
AND (
token = 'TqzYHRVWOaet3M6XubYXcWZwuBIjd4407NndD4SZhU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)