UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTB6ZNQa12KiIU25D5PnlR+3ZA13hm4vVPGXLyBpiAo='
WHERE
key_id = '7b74eff770453fd66d31b14fb53f14300b0270288423d3381edc7e96b0a1ee02'
AND (
token = 'NTB6ZNQa12KiIU25D5PnlR+3ZA13hm4vVPGXLyBpiAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)