UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eoPjWbEfwHJ5dO1XHKtFyp5lHj5cFK+J+hr9T2YZUh8='
WHERE
key_id = '7f14aa739fc503e08a328372c826a29c787ab86f867f74cbb03147e13d6fcdc9'
AND (
token = 'eoPjWbEfwHJ5dO1XHKtFyp5lHj5cFK+J+hr9T2YZUh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)