UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hj4JVNHf1OoTNbwRViqleKpWe1nwvcY5frYAMtLsY5A='
WHERE
key_id = '10f238a8874684923c6eed1713b29f6f29659c9eb39b78b54076b9c2ec579899'
AND (
token = 'Hj4JVNHf1OoTNbwRViqleKpWe1nwvcY5frYAMtLsY5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)