UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DtP7b4ezzdULPYzHZ7IVZvAJ4pxwZEiqLX4cd64ZHa8='
WHERE
key_id = '938729fc4829396d6083ce33b7246f83693997b366ec4106d0559b470688374c'
AND (
token = 'DtP7b4ezzdULPYzHZ7IVZvAJ4pxwZEiqLX4cd64ZHa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)