UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqxNDfePT1JQoglJeNy/1u545EhBSv5gAQrAFeqg/ho='
WHERE
key_id = '9eb320672c6d68a9cc4b5e7be2e5d8a7493b519bc3222e795813f6956b42bb9b'
AND (
token = 'PqxNDfePT1JQoglJeNy/1u545EhBSv5gAQrAFeqg/ho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)