UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y6PXMcs9njRYteUfGXaodD5Y2ba6q/Lanw7iqHmz7pA='
WHERE
key_id = '749f47f6d39bda55e8f3e7154f50a25753afe38a75ecad9584f6b58ebb60b800'
AND (
token = 'Y6PXMcs9njRYteUfGXaodD5Y2ba6q/Lanw7iqHmz7pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)