UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGkxfSX6ZXW/ZT0O7zMT2Y6PEXECnNpGHu3xY3/3YJQ='
WHERE
key_id = '5fea5fbc2957fa033f73dd9a73eaae25d525e7c487b62485a652a638aec1b97f'
AND (
token = 'hGkxfSX6ZXW/ZT0O7zMT2Y6PEXECnNpGHu3xY3/3YJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)