UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ttn8qokTbjnQxyr3VotIVC12E0L68u49goMknVMmsg='
WHERE
key_id = '0bf907fbb2d0ab43fae89a61b5cb810f0b42185b1ff6526d754bf32b937322cc'
AND (
token = '6ttn8qokTbjnQxyr3VotIVC12E0L68u49goMknVMmsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)