UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '19F0mkUi+HKlXQ3ysD5qjTGqO6odU0YjSuAk6MATiZI=' 
WHERE 
  key_id = '80c1db8dcc3357e2d575587dd98cf9d077b6a205eca92a1011907e14b76c4201' 
  AND (
    token = '19F0mkUi+HKlXQ3ysD5qjTGqO6odU0YjSuAk6MATiZI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031