UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xBddf0hgC6mgj3uMjh9EedsHsvGWmdz9rO3QTuPevQ='
WHERE
key_id = 'd9efd3e66060f41000873df54b5ccd63d01003038ab95021dfc3bdbf5a050acb'
AND (
token = '0xBddf0hgC6mgj3uMjh9EedsHsvGWmdz9rO3QTuPevQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)