UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWpbnaUFbEuel7cn1haVyaSi8NAguk783d9lYr8ImII='
WHERE
key_id = 'f87245eb2a63c35cb348a6b11463807c7063e907f787fab699d902bd4d6b61d2'
AND (
token = 'VWpbnaUFbEuel7cn1haVyaSi8NAguk783d9lYr8ImII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)