UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Kr7QWqEK3faN46WNI7K+pOXT9s9kDEJI+waT+ulkT20=' 
WHERE 
  key_id = 'bcdd1f5e1b4388f85a0c3d176a34832af2922546a236d35d0baab82454f61e5e' 
  AND (
    token = 'Kr7QWqEK3faN46WNI7K+pOXT9s9kDEJI+waT+ulkT20=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044