UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z0/WpSbhn4WD8wc8xzz+AO5OEZFP4klojdJ1b1RxD9s=' 
WHERE 
  key_id = '05eb2bd0522a6cd2c1468ce4af3f30f48eee5170de45f4c3c077c39fc100f7bb' 
  AND (
    token = 'Z0/WpSbhn4WD8wc8xzz+AO5OEZFP4klojdJ1b1RxD9s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016