UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eT6pzm5luOm2vzB35D4HilGOGXYAQMsT1Mu3hSCO6Pk='
WHERE
key_id = '8e86ad7cc2b1d9a5d09315b1b6184642e2e6973908ba599780aaddd93c1febcc'
AND (
token = 'eT6pzm5luOm2vzB35D4HilGOGXYAQMsT1Mu3hSCO6Pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)