UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QrBVzgdCcE1SGIO5Pk/6hS1j+hrsHtuLQxoiOO9vh48='
WHERE
key_id = 'a7bcf65a092b8300dc9d3cc6ac66942752fb9673699e2c15c41e4be1d5b69bfc'
AND (
token = 'QrBVzgdCcE1SGIO5Pk/6hS1j+hrsHtuLQxoiOO9vh48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)