UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wr9Z+9EcdVG0TxZi4+RBlbKhhy74vsHZizDTePgUmFM='
WHERE
key_id = 'a4ae4f4929e3b47c11c9387241e5d0e27562905866d11732a632fc4417965d97'
AND (
token = 'wr9Z+9EcdVG0TxZi4+RBlbKhhy74vsHZizDTePgUmFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)