UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aUi/EMHRyf56JCD4sKReeobBZqsylm3qYGK/Y+hhHOU='
WHERE
key_id = 'a4dfc05cbda0e584afc61a672e9b9f20717ffbd95c4b96d6ceac18732a55cb83'
AND (
token = 'aUi/EMHRyf56JCD4sKReeobBZqsylm3qYGK/Y+hhHOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)