UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Jz1cdFJfAnXiXVtq7nQ6LVZ9lsR6HOZpZUt+YrugZuM=' 
WHERE 
  key_id = '72ee27f31e0f7ef4427c2fab72344a00ecb78348b48465ef1571e8caf4b3b169' 
  AND (
    token = 'Jz1cdFJfAnXiXVtq7nQ6LVZ9lsR6HOZpZUt+YrugZuM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023