UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPbp7EDlo7BKHPSW/rl8arf/nDE2p3PodXBkAN5AXsg='
WHERE
key_id = 'f767a36ee5a895093918d69de1939709a437bc5becaf6c8df18adb7324ef626c'
AND (
token = 'tPbp7EDlo7BKHPSW/rl8arf/nDE2p3PodXBkAN5AXsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)