UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8iPJLFyj0vu1SAcIwbPbUpS+Do+Wtu//XAbfm/Qwv4='
WHERE
key_id = 'e9b9ad7546736bcda891daef96850ec2e1c96a48b820cc5b54a9b783dc73b436'
AND (
token = 'Z8iPJLFyj0vu1SAcIwbPbUpS+Do+Wtu//XAbfm/Qwv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)