UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dc9KGKDhBYk1K2Q5yQcv8zawJ9UIkuhPX4cWivOfgno='
WHERE
key_id = '9f9192a1cf2bac096b27ce9ddc41f9d89a30b1592d341030be0e228b71b32f94'
AND (
token = 'dc9KGKDhBYk1K2Q5yQcv8zawJ9UIkuhPX4cWivOfgno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)