UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xsvz9MpuWahDauD119Sn9BMMoNNLCHxuZYCCnK9R0jw='
WHERE
key_id = '847af0ca9e1e035a7344eef99c1bec422b3165142f9a5df843c23ae16a65046d'
AND (
token = 'xsvz9MpuWahDauD119Sn9BMMoNNLCHxuZYCCnK9R0jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)