UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcZrLWuT2m3kY3oj6+IEFtu0dwechEm2DFFO8IsyjEo='
WHERE
key_id = 'c8e0bce28d3ae372309213eac72ca9c6cb235e32e5b40b79d6f6b9dd3d212e41'
AND (
token = 'NcZrLWuT2m3kY3oj6+IEFtu0dwechEm2DFFO8IsyjEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)