UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vsb3yMNLOAQwWkvHlF3xwiJv0enRjGYyp+oSi/HmCy0='
WHERE
key_id = 'c9f25bf3fcf08bdf25b6843b9939d16e8cd45df40735fd47c02faa966c1e3b3f'
AND (
token = 'vsb3yMNLOAQwWkvHlF3xwiJv0enRjGYyp+oSi/HmCy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)