UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hJv02VF/yB7PSACNahQTj7sP3ozFU2wTPze64e5s9os='
WHERE
key_id = 'df5b513396385d2d25396d05b8cf282e6592ef719366f78c4fd0359b99a83ac8'
AND (
token = 'hJv02VF/yB7PSACNahQTj7sP3ozFU2wTPze64e5s9os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)