UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXhgmpc/GCGuqr0iXD83AS6AFGGqlX6/KlH8Whv9dJI='
WHERE
key_id = 'cbe7eee178eb70139acdaaf6d6a4e15007094984a36e9b9dda03f4296c294d9e'
AND (
token = 'JXhgmpc/GCGuqr0iXD83AS6AFGGqlX6/KlH8Whv9dJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)