UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9Z3bX3uIkZU8K4W35yqFXkLIZA1tbl7auy/5phqgWw='
WHERE
key_id = '271aeac923d698795f7aa69d37a8fccae133748198ef5ff444501a5e2732a3ae'
AND (
token = 'r9Z3bX3uIkZU8K4W35yqFXkLIZA1tbl7auy/5phqgWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)