UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IkbbcJ0dR9dvnds1lmovpS7FoV8xpWa2CFqH3Xj/boA=' 
WHERE 
  key_id = 'e22b462ac2d65ef6cea52016c1d05f15f603ec8fc2e74a4afdb05a7fcd737b72' 
  AND (
    token = 'IkbbcJ0dR9dvnds1lmovpS7FoV8xpWa2CFqH3Xj/boA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022