UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xIdetEEByYKx7YjKaOrLH8teXvaLFiWqeyzdN9I9N9M='
WHERE
key_id = 'b64b30470ff625ccca87bcf03730dde763a6cb9428c8a357ffabf2824e9c297a'
AND (
token = 'xIdetEEByYKx7YjKaOrLH8teXvaLFiWqeyzdN9I9N9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)