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